<template>
	<view>
		<view class="uni-header">
			<view class="uni-group">
				<view class="uni-title"></view>
				<view class="uni-sub-title"></view>
			</view>
			<view class="uni-group">
				<!-- 云端数据 -->
				<uni-data-select collection="vm-appid-list" field="appid as value, name as text" label="应用选择" v-model="appid" :clear="false" @change="changeSelect" />
				<input class="uni-search" type="text" v-model="query" @confirm="search" placeholder="请输入搜索内容" />
				<button class="uni-button" type="default" size="mini" @click="search">搜索</button>
				<button class="uni-button" type="default" size="mini" @click="navigateTo('./add')">新增</button>
				<button class="uni-button" type="default" size="mini" :disabled="!selectedIndexs.length" @click="delTable">批量删除</button>
				<download-excel class="hide-on-phone" :fields="exportExcel.fields" :data="exportExcelData" :type="exportExcel.type" :name="exportExcel.filename">
					<button class="uni-button" type="primary" size="mini">导出 Excel</button>
				</download-excel>
			</view>
		</view>
		<view class="uni-container">
			<unicloud-db ref="udb" :collection="collectionList" field="appid,openid,uid,down_video,task_video,device_id,user_ip,is_disabled,child_count,create_time,member_time,update_time" :where="where" page-data="replace" :orderby="orderby" :getcount="true" :manual="true" :page-size="options.pageSize"
				:page-current="options.pageCurrent" v-slot:default="{data,pagination,loading,error,options}" :options="options" loadtime="manual" @load="onqueryload">
				<uni-table ref="table" :loading="loading" :emptyText="error.message || '没有更多数据'" border stripe type="selection" @selection-change="selectionChange">
					<uni-tr>
						<uni-th align="center" filter-type="search" @filter-change="filterChange($event, 'appid')" sortable @sort-change="sortChange($event, 'appid')">应用唯一标识</uni-th>
						<uni-th align="center" filter-type="search" @filter-change="filterChange($event, 'openid')" sortable @sort-change="sortChange($event, 'openid')">openid</uni-th>
						<uni-th align="center" filter-type="search" @filter-change="filterChange($event, 'uid')" sortable @sort-change="sortChange($event, 'uid')">用户ID</uni-th>
						<uni-th align="center" filter-type="search" @filter-change="filterChange($event, 'down_video', 'int')" sortable @sort-change="sortChange($event, 'down_video')">下载广告</uni-th>
						<uni-th align="center" filter-type="search" @filter-change="filterChange($event, 'task_video', 'int')" sortable @sort-change="sortChange($event, 'task_video')">任务广告</uni-th>
						<uni-th align="center" filter-type="search" @filter-change="filterChange($event, 'child_count', 'int')" sortable @sort-change="sortChange($event, 'child_count')">邀请用户数</uni-th>
						<uni-th align="center" filter-type="search" @filter-change="filterChange($event, 'device_id')" sortable @sort-change="sortChange($event, 'device_id')">设备ID</uni-th>
						<uni-th align="center" filter-type="search" @filter-change="filterChange($event, 'user_ip', 'int')" sortable @sort-change="sortChange($event, 'user_ip')">用户IP</uni-th>
						<uni-th align="center" sortable @sort-change="sortChange($event, 'is_disabled')">用户状态</uni-th>
						<uni-th align="center" filter-type="search" @filter-change="filterChange($event, 'create_time')" sortable @sort-change="sortChange($event, 'create_time')">创建时间</uni-th>
						<uni-th align="center" filter-type="search" @filter-change="filterChange($event, 'member_time')" sortable @sort-change="sortChange($event, 'member_time')">会员到期时间</uni-th>
						<uni-th align="center" filter-type="search" @filter-change="filterChange($event, 'update_time')" sortable @sort-change="sortChange($event, 'update_time')">最近访问时间</uni-th>
						<uni-th align="center">操作</uni-th>
					</uni-tr>
					<uni-tr v-for="(item,index) in data" :key="index">
						<uni-td align="center">{{item.appid}}</uni-td>
						<uni-td align="center">{{item.openid}}</uni-td>
						<uni-td align="center">{{item.uid}}</uni-td>
						<uni-td align="center">{{item.down_video}}</uni-td>
						<uni-td align="center">{{item.task_video}}</uni-td>
						<uni-td align="center">{{item.child_count ?? 0}}</uni-td>
						<uni-td align="center">{{item.device_id ?? '--'}}</uni-td>
						<uni-td align="center">{{item.user_ip ?? '--'}}</uni-td>
						<uni-td align="center">{{item.is_disabled == true ? '禁用❌' : '正常✅'}}</uni-td>
						<uni-td align="center"><uni-dateformat :date="item.create_time"></uni-dateformat></uni-td>
						<uni-td align="center">
							<uni-dateformat :date="item.member_time" v-if="item.member_time>0 && item.member_time < 2208960000000"></uni-dateformat>
							<span v-if="item.member_time >= 2208960000000">永久会员</span>
							<span v-if="item.member_time == -1">会员过期</span>
							<span v-if="item.member_time == 0">--</span>
						</uni-td>
						<uni-td align="center"><uni-dateformat :date="item.update_time"></uni-dateformat></uni-td>
						<uni-td align="center">
							<view class="uni-group">
								<button @click="navigateTo('./edit?id='+item._id+'&collectionName='+collectionList, false)" class="uni-button" size="mini" type="primary">修改</button>
								<button @click="confirmDelete(item._id)" class="uni-button" size="mini" type="warn">删除</button>
							</view>
						</uni-td>
					</uni-tr>
				</uni-table>
				<view class="uni-pagination-box">
					<uni-pagination show-icon :page-size="pagination.size" v-model="pagination.current" :total="pagination.count" @change="onPageChanged" />
				</view>
			</unicloud-db>
		</view>
	</view>
</template>
<script>
	import { enumConverter, filterToWhere } from '@/js_sdk/validator/vm-user.js';
	const db = uniCloud.database()
	// 表查询配置
	const dbOrderBy = '' // 排序字段
	const dbSearchFields = [] // 模糊搜索字段，支持模糊搜索的字段列表。联表查询格式: 主表字段名.副表字段名，例如用户表关联角色表 role.role_name
	// 分页配置
	const pageSize = 20
	const pageCurrent = 1
	const orderByMapping = {
		"ascending": "asc",
		"descending": "desc"
	}
	export default {
		data() {
			return {
				appid: "",
				collectionList: "",
				query: '',
				where: '',
				orderby: dbOrderBy,
				orderByFieldName: "",
				selectedIndexs: [],
				options: {
					pageSize,
					pageCurrent,
					filterData: {},
					...enumConverter
				},
				imageStyles: {
					width: 64,
					height: 64
				},
				exportExcel: {
					"filename": "vm-user.xls",
					"type": "xls",
					"fields": {
						"应用唯一标识": "appid",
						"openid": "openid",
						"用户ID": "uid",
						"下载广告": "down_video",
						"任务广告": "task_video",
						"创建时间": "create_time",
						"会员到期时间": "member_time",
						"最近访问时间": "update_time"
					}
				},
				exportExcelData: []
			}
		},
		onLoad() {
			this._filter = {}
		},
		onReady() {
			db.collection('opendb-app-list').get().then((res) => {
				const apps = res.result.data;
				if (apps.length > 1) {
					this.appid = apps[1].appid;
					this.collectionList = `vm-user_${apps[1].appid.split('__UNI__')[1]}`;
					this.$nextTick(() => {
						this.$refs.udb.loadData()
					})
				} else {
					uni.showModal({
						title: '请先添加管理的应用',
						content: '即将跳转至应用管理……',
						showCancel: false,
						confirmText: '立即跳转',
						success: (res) => {
							uni.navigateTo({
								url: '/pages/system/app/list'
							})
						}
					})
				}
			}).catch((err) => {}).finally(() => {})
		},
		methods: {
			changeSelect(e) {
				const userListName = `vm-user_${e.split('__UNI__')[1]}`
				if (userListName == this.collectionList) return;
				this.collectionList = userListName;
				this.search();
			},
			onqueryload(data) {
				this.exportExcelData = data
			},
			getWhere() {
				const query = this.query.trim()
				if (!query) {
					return ''
				}
				const queryRe = new RegExp(query, 'i')
				return dbSearchFields.map(name => queryRe + '.test(' + name + ')').join(' || ')
			},
			search() {
				const newWhere = this.getWhere()
				this.where = newWhere
				this.$nextTick(() => {
					this.loadData()
				})
			},
			loadData(clear = true) {
				this.$refs.udb.loadData({
					clear
				})
			},
			onPageChanged(e) {
				this.selectedIndexs.length = 0
				this.$refs.table.clearSelection()
				this.$refs.udb.loadData({
					current: e.current
				})
			},
			navigateTo(url, clear) {
				// clear 表示刷新列表时是否清除页码，true 表示刷新并回到列表第 1 页，默认为 true
				uni.navigateTo({
					url,
					events: {
						refreshData: () => {
							this.loadData(clear)
						}
					}
				})
			},
			// 多选处理
			selectedItems() {
				var dataList = this.$refs.udb.dataList
				return this.selectedIndexs.map(i => dataList[i]._id)
			},
			// 批量删除
			delTable() {
				this.$refs.udb.remove(this.selectedItems(), {
					success: (res) => {
						this.$refs.table.clearSelection()
					}
				})
			},
			// 多选
			selectionChange(e) {
				this.selectedIndexs = e.detail.index
			},
			confirmDelete(id) {
				this.$refs.udb.remove(id, {
					success: (res) => {
						this.$refs.table.clearSelection()
					}
				})
			},
			sortChange(e, name) {
				this.orderByFieldName = name;
				if (e.order) {
					this.orderby = name + ' ' + orderByMapping[e.order]
				} else {
					this.orderby = ''
				}
				this.$refs.table.clearSelection()
				this.$nextTick(() => {
					this.$refs.udb.loadData()
				})
			},
			filterChange(e, name, type) {
				this._filter[name] = {
					type: e.filterType,
					value: type == 'int' ? e.filter ? Number(e.filter) : e.filter : e.filter
				}
				let newWhere = filterToWhere(this._filter, db.command)
				if (Object.keys(newWhere).length) {
					this.where = newWhere
				} else {
					this.where = ''
				}
				if (this.where?.member_time && this.where?.member_time.test('永久')) {
					this.where = 'member_time>2208960000000'
				}
				this.$nextTick(() => {
					this.$refs.udb.loadData()
				})
			}
		}
	}
</script>
<style>
</style>